You are here : Purchase > Purchase Masters > Item Vendor Labour Master Entry

Item Vendor Labour Master Entry

 

This option allows to add and maintain Item - Subcontractor relationship in case of manufactured items. Existing Process Sheets / Work Order Process Sheet of an Item is available so that details such as the Vendor, Rate for particular operation, Discounts offered and the applicable Rate Structure can be entered for each operation. Final cost of the operation is calculated using these figures. You can maintain multiple Vendors and related details for an operation. Additionally, a default Vendor can also be declared for a particular combination of Item and its operation.

 

Apart from the manufactured Items, this option also allows to maintain Item - Subcontractor relationship in case of 'Bought Out' and 'Ready Sub-Assembly' type of Items for which some kind of Process is required.

 

But this facility is available ONLY if the flag 'Do you require Process defined in Item Master for an Item?' is set as 'On' through Inventory Policy option of Administrator Tools Module.

 

Authorization of Item Vendor Labour relationships is a flag driven option. Therefore its availability depends upon the setting of the 'Authorization Required' flag through Authorization of Transactions option in Administrator Tools Module. CollapsedRead more...

 

Item Vendor Labour relationship can be added, edited, deleted and viewed provided the Role associated with the currently logged-in user through User Management has the respective rights to do so.

To 'Add' an Item Vendor Labour relationship, click on the button and to 'Edit', click on the icon on the top right hand of the screen. To view details of a particular relationship, just select the desired Item. As a result, following screen will be displayed -

Screen Layout of Item Vendor Labour Master Entry

Field Description of Item Vendor Labour Master Entry

Item:

Click on the icon to access a list of Items defined through Item Master Basic Detail - Entry option in Materials Module. Select your desired Item from the list by scrolling down to it and click on 'Continue' button.

 

You can not select an Item that has been deactivated through Activate/De-Activate Master option in Administrator Tools Module. The help will also not display such items.

 

Please note that while 'Adding',

  • Only those manufactured and Assembly Items will be considered that already have a Process Sheet defined through Materials Module or Work Order Process Sheet defined through Planning Module.
  • Process Sheet / Work Order Process Sheet of such Manufactured / Assembly type of Items should include an outside operation.
  • Only those 'Bought Out' and 'Ready Sub-Assembly' type of Items will be considered for which the field 'Process Flag' has been set as 'On' through Item Master Basic Detail - Entry option of Materials Module. Otherwise the system will not allow to enter Bought Out / Ready Sub-Assembly type of Items.

In case of 'Edit', and 'View', only those Items will be displayed/accepted for which Vendors have already been associated.

 

Now as you can see the screen has been divided into two sections. The left hand section displays the Operations associated with the Item in a list format. Whereas the right hand grids displays the Vendors associated with the Item and the details of Rate Structures.

 

In case the selected Item is a Manufactured or Assembly Type of Item, the left hand list automatically displays the Operations mentioned in Process Sheet / Work Order Process Sheet of the selected Item .

Please note that if the 'Process Flag' is set as 'On' for the Item through Item Master Basic Detail - Entry option of Materials Module, the system will display both, Inside and Outside Operations mentioned in the Process Sheet / Work Order Process Sheet of the Item. If the flag is set as 'Off', the system will display only the Outside Operations.

 

Whereas if the selected Item is a Bought Out or Ready Sub-Assembly Type of Item, the left hand list automatically displays the Process Operation specified for that Item through Item Master Basic Detail - Entry option of Materials Module.

 

Select a particular Operation by clicking on it in order to link a sub-contractor with it.

 

Left hand list

 

As a result the right hand side section will become active and two grid will be displayed.

 

Right hand grids

 

The top grid displays the Sub-Contractors associated (if any) with the selected Operation. The bottom grid displays the details of the Rate Codes belonging to the Rate Structure associated with the selected Sub-Contractor.

Please note that in 'Add' mode,

Whereas in case of 'Edit', you can not add or change any associate Sub-Contractor but you can only change some of the existing data.

 

Field Description of the grid -

Now specify the Sub-Contractor and other details to link with the operation you have selected.

Action

Click on the icon to remove a record from the grid. Click on the 'Delete' icon again to un-delete the record.

Vendor Code:

Specify the Sub-Contractor associated with the selected Operation.

 

While 'Adding', click on the icon to access a list of Vendors defined through Vendor Master Entry. Select your desired Vendor from the list by scrolling down to it and click on 'Continue' button.

You can not select a Vendor that has been deactivated through Activate/De-Activate Master option in Administrator Tools Module. The help will also not display such Vendors

 

In case of 'Edit', and 'View', Vendor Code will be displayed for the selected Item + Operation.

Vendor Name:

Name of the Vendor is displayed automatically as per the selected Vendor Code from Vendor Master.

 

Purchase UOM:

Denotes the Unit of Measurement in which the Item will be sub-contracted from the Vendor.

Click on the field to access a list of Unit of Measurement specified for the selected Item through Item Master Purchase Entry option. Select your desired UOM from the list by scrolling down to it and pressing <ENTER>.

 

Please note that only the 'Sub-Contracting' Unit of Measurement will be displayed.

PUOM Description:

Description of the selected Sub-Contracting Unit of Measurement will be displayed automatically.

 

Quantity:

(Type : Numeric, Length : 9.4)

 

While 'Adding', '1' will be displayed by default but it can be changed. To do so, click on the field. Now enter the quantity of Item. Press <TAB>.

 

In case of 'Edit', and 'View', Quantity will be displayed automatically for the selected combination of Item Code, Operation and Vendor. You can change Quantity in 'Edit' mode.

 

Vendor Priority:

Denotes the Priority of the Vendor for the said Operation.

 

In case of 'Add' and 'Edit', click on the field to enter the Vendor Priority.

 

Currency Code:

Denotes the Currency Code in which the selected Vendor deals in.

In case of 'Add' mode, the selected Vendor's Currency as specified through Vendor Master Entry option will be displayed by default.

 

But IMMS also provides the facility to maintain Item Vendor relationship in currencies other than this. Click on the field to access a list of Currencies defined through Currency Master option of Administrator Tools Module. Select your desired Currency from the list by scrolling down to it and pressing <ENTER>. Press <TAB>.

 

In case of 'Edit' and 'Search' modes, the Currency of the Vendor already specified for the selected Item and Operation will be displayed automatically. It can NOT be changed in 'Edit' mode.

Currency Description:

Displays the Description of the Currency Code for your reference.

 

Basic Pur Price:

(Type : Numeric, Length : 9.4)

 

Click on the field. Enter the Basic Price offered by the Vendor for Sub-Contracting on the Item. Press <TAB>.

Discount Type:

Click on the field. Select the Type of Discount offered by the Vendor for the Item from the list. It can be 'None', 'Percentage' or 'Value'.

 

Discount Value:

In case of 'Percentage' and 'Value', this field will be enabled to enter the figure. In case of 'None', it will be disabled.

Landed Price:

Item's Landed Price is calculated automatically using its Basic Price, applicable Rate Structure and Discount offered if any.

 

If the selected Vendor deals in foreign currency, IMMS takes care of calculating the Item's Landed Price accordingly.

 

Item's Landed Price is calculated as follows -

Rate Structure:

Click on the field to access a list of Rate Structures defined through Rate Structure Master - Entry. Select your desired Rate Structure from the list by scrolling down to it and pressing <ENTER>.

Once the Rate Structure is specified, another screen below displays all the information related to that Rate Structure for your reference. Read more...

Rate Stru Description:

Description of the selected Rate Structure Code will be displayed automatically for your reference.

 

Other Details:

Click on the link shown in the field. As a result, following screen appear -

 

Reason Code:

Click on the field to access a list of Reason Codes defined through Codes Master Entry (Code Type = 'RC') option in Administrator Tools Module. Select your desired Reason from the list by scrolling down to it and pressing <ENTER>.

 

Remark:

Enter any Remarks related to this entry.

Landed Cost:

Automatically displays the landed cost for your information.

 

Last Updated:

Automatically displays the last Date on which editions were done.

Once done, click on 'Ok' button to continue or 'Cancel' button to discard. The control goes back to the grid.

Delivery Days:

(Type : Numeric, Length : 3)

 

Click on the field. Enter the number of days required to deliver the Item by the Vendor. Press <TAB>.

Create User Code - Name:

Automatically displays the Code and Name of the logged in User who has created the Item Vendor Labour relationship. You can NOT change it.

 

Last Update Date:

Automatically displays the last Date and Time on which changes were done.

Is Default:

Specify whether or not the Vendor is a default for the said Item. There can be only one default Vendor for an Item. To do so, click on the small white box.

 

Tick mark in the box denotes that the Vendor is a default Vendor for the Item. While creating a Purchase Order for this Item, the default Vendor will be displayed initially which if required can be changed by the user.

 

Empty box denotes that the Vendor is not a default one for the Item.

 

Active:

Denotes whether the combination of Item, Vendor, PUOM, Currency Code and Rate Structure is active or not. In case it is Active, the box will be displayed as ticked and this particular combination will be available to enter in Purchase Order. In case it is inactive, the box will be displayed empty and as a result the combination will not be available to enter in Purchase Order.

 

Vendor Status Active:

Automatically displays the current status of the selected Vendor. If the Vendor is Active, the checkbox will be displayed as ticked else it will be displayed empty. You can NOT change it here.

Minimum Order Quantity (PUOM):

(Type : Numeric, Length : 8.4)

 

Please note that if the flag 'Do you want to use Master Control Form' is set as 'On' through Purchase Policy option of Administrator Tools Module, the user can NOT change the value of this field in 'Edit' mode. But it can be entered while adding a new entry in 'Add' mode.

 

If the flag is set as 'Off', the user can add or edit the value of this field.

 

Click on the field. Enter the Minimum Quantity that can be ordered for the selected Item from the selected Vendor. It can NOT be zero. Press <TAB>.

 

IMMS provides the facility to restrict the number of digits that can be entered after the decimal in this field for each Purchase Unit of Measurement. Therefore the number of digits that can be entered after decimal in this field will be same as the number entered in 'Digits After Decimal' for the current PUOM through Codes Master - Entry (Code Type = 'UM') option of Administrator Tools Module.

 

Maximum Order Quantity (PUOM):

(Type : Numeric, Length : 8.4)

Click on the field. Enter the Maximum Quantity that can be ordered for the selected Item from the selected Vendor. It can NOT be zero and should be more than the Minimum Order Quantity. Press <TAB>.

 

IMMS provides the facility to restrict the number of digits that can be entered after the decimal in this field for each Purchase Unit of Measurement. Therefore the number of digits that can be entered after decimal in this field will be same as the number entered in 'Digits After Decimal' for the current PUOM through Codes Master - Entry (Code Type = 'UM') option of Administrator Tools Module.

 

EOQ (PUOM):

(Type : Numeric, Length : 8.4)

 

Please note that if the flag 'Do you want to use Master Control Form' is set as 'On' through Purchase Policy option of Administrator Tools Module, the user can NOT change the value of this field in 'Edit' mode. But it can be entered while adding a new entry in 'Add' mode.

 

If the flag is set as 'Off', the user can add or edit the value of this field.

 

Enter Economic Value that can be ordered for the selected Item from the selected Vendor. It should be less than or equal to the Minimum Order Quantity.

There are certain items which are available as per their standard minimum measurements only. Such items have to be purchased in the multiples of the value specified in Economic Order. For example if a rod is available in standard measurement of 6 meters and the requirement is of 10 meters, then the rod has to be procured in the multiples of 6, i.e., 12 meters.

IMMS provides the facility to restrict the number of digits that can be entered after the decimal in this field for each Purchase Unit of Measurement. Therefore the number of digits that can be entered after decimal in this field will be same as the number entered in 'Digits After Decimal' for the current PUOM through Codes Master - Entry (Code Type = 'UM') option of Administrator Tools Module.

 

Exchange Rate:

Automatically displays the latest Exchange Rate of the Currency specified through the Exchange Rate Master Entry option in Administrator Tools Module.

 

HSN Number:

(Type : Numeric, Length : 8)

 

Click on the field. Now enter the HSN Number for the combination of Item + Vendor + Operation. It should be either 2, 4 or 8 digits only. Otherwise IMMS will display an appropriate message regarding the same. Press <TAB>.

 

Please note that if HSN Number has been entered, SAC Code can not be entered and so the field will become disabled.

 

SAC Code:

(Type : Numeric, Length : 8)

 

Click on the field. Now enter the SAC Code for the combination of Item + Vendor + Operation. It can be of less than or equal to 8 digits. Press <ENTER> again.

 

Please note that if SAC Code has been entered, HSN Number can not be entered and so the field will become disabled.

Rate Structure Details

A list of all 'Excluded' Rate Codes specified for the selected Rate Structure will be displayed in a grid as follows -

Please note that if your company has opted to calculate Landed Cost with Non Postable Taxes only, this grid will display only Excluded and Non-Postable taxes of the selected Rate Structure. Otherwise both Excluded Postable and Excluded Non-Postable taxes will be considered.

Field Description of the grid -

Index:

System generated sequence number.

 

Rate Code:

Automatically displays the Rate Code that belongs to the selected Rate Structure. It can not be changed.

 

Rate Desc.:

Automatically displays the description of the Rate Code. It can not be changed.

 

I/E:

Automatically displays whether the Rate Code is Included or Excluded as specified through Tax Rate Master - Entry option for your reference. It can NOT be changed.

 

P/V:

Automatically displays whether the value of the selected Rate Code is in Value or Percentage as specified through Tax Rate Master - Entry option for your reference. It can NOT be changed.

 

Applicable On:

Automatically displays the Rate Codes on which this particular Rate Code is applicable. It can NOT be changed.

 

Tax Value:

Automatically displays the Value of the Rate Code as specified through Tax Rate Master - Entry option for your reference. It can NOT be changed.

 

Post/Non post:

Automatically displays whether the selected Rate Code is Postable or Non Postable in Purchase as specified through Tax Rate Master - Entry option for your reference. If it is Postable, the box will be displayed as checked otherwise it will be displayed empty. It can NOT be changed.

 

Rate Amount:

In case of 'Percentage', the Rate Amount field in the grid is calculated automatically as % (entered in Tax Value field) of 'Basic Pur Price'. In case of 'Value', the entered amount of tax is displayed as it is.

 

Please note that if the 'Basic Pur Price' is entered in Foreign Currency and the Rate Code is also in Foreign Currency, the 'Basic Pur Price' will be considered as it is. But if the 'Basic Pur Price' is entered in Foreign Currency and Rate Code is in Domestic Currency, 'Basic Pur Price' is first converted into Domestic Currency by using the latest Exchange Rate.

 

Total Amount:

Automatically calculates and displays the Total Tax Amount as 'Basic Pur Price' + 'Rate Amount'. It can not be changed.

 

Currency Code:

Automatically displays the Currency of the Current Rate Code. It can not be changed.

Once you have entered all the information, click on 'Save' button to save or 'Cancel' button to discard.